<%-- 
    Document   : query_employee
    Created on : 2019-6-17, 20:43:54
    Author     : 虎
--%>

<%@page import="com.jdbc.domains.Usertable1"%>
<%@page import="com.jdbc.dao.impl.Usertable1DaoImpl"%>
<%@page import="java.util.List"%>
<%@page import="com.jdbc.daos.Usertable1Dao"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <table>
            <caption>员工信息表<hr></caption>
            <tr>
                <th>工号</th>
                <th>姓名</th>
                <th>性别</th>
                <th>身份证号</th>
                <th>出生日期</th>
                <th>年龄</th>
                <th>手机号</th>
                <th>籍贯</th>
                <th>邮箱</th>
                <th>职位</th>
            </tr>
<%
            Usertable1Dao dao = new Usertable1DaoImpl();
            List<Usertable1> allUser= dao.listAll(1);  
            for(Usertable1 u1 : allUser){
%>
            <tr>
                <td><%=u1.getJob_number1()%></td>
                <td><%=u1.getEmployee_name()%></td>
                <td><%=u1.getSex()%></td>
                <td><%=u1.getID()%></td>
                <td><%=u1.getBirthday()%></td>
                <td><%=u1.getAge()%></td>
                <td><%=u1.getPhone()%></td>
                <td><%=u1.getProvince()%></td>
                <td><%=u1.getEmail()%></td>
                <td><%=u1.getPost()%></td>
            </tr>
<%
            }
%>
        </table>
    </body>
</html>
